home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Info-Mac 4
/
Info_Mac IV CD-ROM (Pacific HiTech Inc.)(August 1994).iso
/
Applications
/
EVDesign 1.1
/
MiscInfo
/
EV_FAQ
/
evlistdb.txt
< prev
Wrap
Text File
|
1994-05-21
|
5KB
|
124 lines
Introduction to the Database Search Capabilities of the Listserver
Written by: Scott Askew <askew@aio.jsc.nasa.gov>
This electronic discussion group is also an email accessible database of all
the information ever sent to it. For new users you can get background info.
on specific topics and for other users you can retrieve details of something
you remember seeing on the net a while back. You no longer need to save
voluminous material on your disk or ask others to repeat info that has
already been discussed. Its pretty simple to get started and if you are so
inclined there is much more detailed info. to give you greater power to
retrieve information from this list.
Here are the basics
1. All database requests should be sent to: LISTSERV@SJSUVM1.SJSU.EDU
(or the equivalent BITNET address). This is the listserver for our group.
2. You will need to create a batch job skeleton to include in your email
message to the listserver. This lets the listserver know you want it to do a
database search for you and your commands give it instructions on what to
look for. Every time you send this skeleton to the listserver you give it a
JOB to do.
// JOB Echo=No
Database Search DD=Rules
//Rules DD *
command 1 (these are your instructions)
command 2
etc.
/*
3. Searching the Database
You may use one or more of the following patterns to define a search:
A) Search [WORD OR WORDS] in [DATABASE TO USE] (ours is EV)
B) Search [WORD(S)] in EV since, until, from/to [DATE(S)]
C) Search [WORD(S)] in EV where [KEYWORD] contains, does not contain
[WORD(S)]
NOTE: Letter prefixes are only added here and below to identify different
search types that can be used. The letters should not be used when
sending a JOB to the listserver.
Examples:
A) Search low rolling resistance tire in EV
This will find entries with of all the above words in any order in the EV
database
A) Search "American Flywheel Systems" in EV
This will find all occurrences of all the exact phrase in quotes in any of the
messages in the EV database
B) Search Tropica in EV since march 94
This will find the word Tropica in any entries since March 1, 1994.
B) Search Big Three stalling from 12 january 93 to august 93 in EV
This will find all specified entries between Jan. 12, 1993 and Aug. 31,
1993. NOTE: where you put the date info. is not important.
B) Search Horizon Battery until 31 dec 93 in EV
B) Search controller schematic in EV since today 11:53
More date search options
C) Search * in EV where subject does not contain C5
Keyword search with the subject NOT containing C5. * is a wildcard.
C) Search SCR in EV where sender contains poche
Keyword search of sender containing poche.
NOTE: You must use all or part of the email address not the person's name.
4. Getting your results
Now that you have conducted a search, you need to inform the listserver
how you want the results sent to you. The basic options are:
A) Index
This command will give a listing of the message numbers and titles that
were found using the search command. From this list you can decide if you
want to make another more specific search or to print some or all of the
results in your next JOB.
B) Print [PRINT LIST]
This command will print (send you a mail copy of the message) entries
that were found in the previous search or specific items from an index list.
NOTE: Unless you conduct a specific search and know there will only be a
few matches you should probably use Index first to see what you will get
and then send a follow-up JOB to print what you want.
Examples:
Search low rolling resistance tire in EV
Index
The listserver will return a message containing an index of the items
matching the search. To print a specific message or messages from the
index listing any of the following command could be used in the next JOB
sent to the listserver.
Print 3163
Print this one item.
Print 3163-3167
Print this range of items.
Print 3163 4065
Print these two items. You can print multiple combinations items and
ranges.
Search controller schematic in EV since today 11:53
5. A Few more tips
* can be used as a wildcard in the word field.
Search * in EV
- is used at the end of a line to extend the command to multiple lines.
Search price in EV -
from 1 jan 94 to today -
where sender does not contain salesman@snakeoil.con
Logical operators can be used and nested
Search ((tropica or impact or kewet) and price) in EV
A full guide to the database capabilities can be obtained by sending
INFO DATABASE
in email to the listserver. This is not a JOB format its just like how
you signed on to the list to begin with.
Experiment and get the full use from the resources available to you. The
database is pretty straightforward and can provide you with lots of
information.